How to highlight errors in Excel
I am trying to format cells within an Excel spreadsheet to highlight errors, but it is not including the cells with "#####". How can I format the spreadsheet to highlight these cells? I currently have a spreadsheet that is populated with…
Any idea why xlfFormulaConvert / Application.ConvertFormula would fail in Excel?
If I try to call xlfFormulaConvert (C-API) with same result in COM Application.ConvertFormula on the following formula, it throws "#VALUE/Error 2015" exception, but if I do convert on each part of the formula, they work. Is it because I need…
HPC com Excel
Ola, estou com dificuldade em executar tarefa entre 3 computadores, sendo que os 3 computadores já estão conectados, 2 no windows serve 2019 e o nó principal está com windows 10, quando Clico em New Job e configuro *test.bat * um teste retirado da…
"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."
One of the users receive this error. is this issue at our end or at microsofts ?
Can the Excel Image function accept a "data" url as the source?
Hello, I'm currently developing a Javascript add-in for Excel. During the development process, I have used both the addImage function to include images and the WebImage data type. The current interaction of the code is using the WebImage data type. The…
Excel Fill schedule
Hi, I use a schedule sheet like the one in the photo. I would like it so when the times are input to the C column, the bars along the schedule are filled in automatically. Like the example in the photo
FileOpenUserUnauthorized error for excel API
Hi, I hope you are doing well. I am exploring Microsoft Graph Explorer for excel API and testing get worksheets in workbook endpoint. Although I have provided correct drive-item-id , I'm keep getting following error. { "error": { …
how to open local excel file in web browser without upload to cloud storage
After saving the excel file using Python, I want to open it in a web browser.
My TAB BUTTON in Excel doesn't work as usual
Hi all, As usual I press TAB button to move to the next cell on the right (in Microsoft Excel) but recently it moves to the edge of the screen. For example From A1 to B1 is normal but it will move from A1 to U1, or B1, C1, .....T1 to U1 (Column U is in…
Issues connecting Onedrive Excel sheet to third party app
To start off, I want to say that I am in no way a developer or know any coding. So forgive me if I am unable to explain this efficiently. Here is what I am trying to do: I build a very basic app with go.glideapps to show all the vehicles i have. The data…
ボリュームライセンス版のExcelとOffice 365 Apps for enterpriseのExcelの終了処理の違いを知りたいについて
ボリュームライセンス版のExcelとOffice 365 Apps for enterpriseのExcelで Excel.exeの終了処理に違いはあるかご教示いただきたくお願いします。 終了までの時間を比較したところOffice 365 Apps for enterpriseのExcel版がボリュームライセンス版の Excelより約3秒~6秒ほど遅い場合があるためその理由を知りたく質問させていただきました。 宜しくお願いいたします。
Word Excel in Microsoft 365 subsciption is not working properly
Word Excel tool in Microsoft 365 subscription is not working properly. Can someone help me
How to fix error AADSTS500200: User account is a personal Microsoft account. Personal Microsoft accounts are not supported for this application
Sorry, but we’re having trouble signing you in. AADSTS500200: User account 'su*****sk@gmail.com' is a personal Microsoft account. Personal Microsoft accounts are not supported for this application unless explicitly invited to an organization. Try signing…
Recommended approach to adding web pane to Excel worksheet
We are using the Javascript API to write an Excel add-in. The app runs well in the task pane. We are making good headway on that, but there is a specific feature we want to support that is challenging to find an answer for: How can we utilize the…
How to Default name of the user who signed in to an Excel field
Hi, I want to default name of the user who Signed in to an excel field and make it non editable. If user not signed in, prompt as 'Please Sign In'. Please advice how to do it. Regards, Sudheer.
Practice tests for MO-110 and MO-210
Hello, I plan on studying for the certification exams MO-110 and MO-210. Where can I find free practice exams for these? Also, I have already practiced for MO-110 using the practice files by Microsoft but could not find anything for the Excel exam…
Refresh of Exported SharePoint list keeps failing
I have a report set up in Excel that is linked to a SharePoint list and it worked fine for weeks. But recently when I now click Refresh All, I get a message saying 'a connection to the SharePoint sire cannot be established. To synchronise or refresh your…
Resize table using VBA
Hello, I currently use the following code in order to copy data to another worksheet. However, when I eliminate rows on the original worksheet, the range of the table for the second worksheet remains the same when I run the macro. I was wondering if…
how to remove auto group window
how to remove this, I don't want this auto group and add another window too many function and lag, too slow when i want to change my work book. if i want another group from a-b to a-c? y create auto group?
Workbook.refreshAllDataConnections() is not supported in Power Automate.
Dear all, I have an excel sheet with an active connection which I am able to refresh to get the newest data. Now I've got another PowerAutomate Flow which is working fine with a script inside this Sheet to send me via Teams numbers which I want to be…